/*
 Navicat Premium Dump SQL

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 80034 (8.0.34)
 Source Host           : 172.19.0.5:3306
 Source Schema         : tlias

 Target Server Type    : MySQL
 Target Server Version : 80034 (8.0.34)
 File Encoding         : 65001

 Date: 11/07/2024 23:44:23
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for dept
-- ----------------------------
DROP TABLE IF EXISTS `dept`;
CREATE TABLE `dept` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(10) COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门名称',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='部门表';

-- ----------------------------
-- Records of dept
-- ----------------------------
BEGIN;
INSERT INTO `dept` (`id`, `name`, `create_time`, `update_time`) VALUES (1, '学工部', '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `dept` (`id`, `name`, `create_time`, `update_time`) VALUES (2, '教研部', '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `dept` (`id`, `name`, `create_time`, `update_time`) VALUES (3, '咨询部', '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `dept` (`id`, `name`, `create_time`, `update_time`) VALUES (4, '就业部', '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `dept` (`id`, `name`, `create_time`, `update_time`) VALUES (5, '人事部', '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `dept` (`id`, `name`, `create_time`, `update_time`) VALUES (6, '屌毛', '2024-07-11 23:14:41', '2024-07-11 23:14:41');
INSERT INTO `dept` (`id`, `name`, `create_time`, `update_time`) VALUES (9, '屌毛3', '2024-07-11 23:16:56', '2024-07-11 23:16:56');
COMMIT;

-- ----------------------------
-- Table structure for emp
-- ----------------------------
DROP TABLE IF EXISTS `emp`;
CREATE TABLE `emp` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `username` varchar(20) COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(32) COLLATE utf8mb4_general_ci DEFAULT '123456' COMMENT '密码',
  `name` varchar(10) COLLATE utf8mb4_general_ci NOT NULL COMMENT '姓名',
  `gender` tinyint unsigned NOT NULL COMMENT '性别, 说明: 1 男, 2 女',
  `image` varchar(300) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图像',
  `job` tinyint unsigned DEFAULT NULL COMMENT '职位, 说明: 1 班主任,2 讲师, 3 学工主管, 4 教研主管, 5 咨询师',
  `entrydate` date DEFAULT NULL COMMENT '入职时间',
  `dept_id` int unsigned DEFAULT NULL COMMENT '部门ID',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='员工表';

-- ----------------------------
-- Records of emp
-- ----------------------------
BEGIN;
INSERT INTO `emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (1, 'jinyong', '123456', '金庸', 1, '1.jpg', 4, '2000-01-01', 2, '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (2, 'zhangwuji', '123456', '张无忌', 1, '2.jpg', 2, '2015-01-01', 2, '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (3, 'yangxiao', '123456', '杨逍', 1, '3.jpg', 2, '2008-05-01', 2, '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (4, 'weiyixiao', '123456', '韦一笑', 1, '4.jpg', 2, '2007-01-01', 2, '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (5, 'changyuchun', '123456', '常遇春', 1, '5.jpg', 2, '2012-12-05', 2, '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (6, 'xiaozhao', '123456', '小昭', 2, '6.jpg', 3, '2013-09-05', 1, '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (7, 'jixiaofu', '123456', '纪晓芙', 2, '7.jpg', 1, '2005-08-01', 1, '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (8, 'zhouzhiruo', '123456', '周芷若', 2, '8.jpg', 1, '2014-11-09', 1, '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (9, 'dingminjun', '123456', '丁敏君', 2, '9.jpg', 1, '2011-03-11', 1, '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (10, 'zhaomin', '123456', '赵敏', 2, '10.jpg', 1, '2013-09-05', 1, '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (11, 'luzhangke', '123456', '鹿杖客', 1, '11.jpg', 5, '2007-02-01', 3, '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (12, 'hebiweng', '123456', '鹤笔翁', 1, '12.jpg', 5, '2008-08-18', 3, '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (13, 'fangdongbai', '123456', '方东白', 1, '13.jpg', 5, '2012-11-01', 3, '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (14, 'zhangsanfeng', '123456', '张三丰', 1, '14.jpg', 2, '2002-08-01', 2, '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (15, 'yulianzhou', '123456', '俞莲舟', 1, '15.jpg', 2, '2011-05-01', 2, '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (16, 'songyuanqiao', '123456', '宋远桥', 1, '16.jpg', 2, '2007-01-01', 2, '2024-07-11 22:34:30', '2024-07-11 22:34:30');
INSERT INTO `emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (17, 'chenyouliang', '123456', '陈友谅', 1, '17.jpg', NULL, '2015-03-21', NULL, '2024-07-11 22:34:30', '2024-07-11 22:34:30');
COMMIT;

-- ----------------------------
-- Table structure for operate_log
-- ----------------------------
DROP TABLE IF EXISTS `operate_log`;
CREATE TABLE `operate_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `operate_user` int unsigned DEFAULT NULL COMMENT '操作人ID',
  `operate_time` datetime DEFAULT NULL COMMENT '操作时间',
  `class_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作的类名',
  `method_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作的方法名',
  `method_params` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '方法参数',
  `return_value` varchar(2000) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '返回值',
  `cost_time` bigint DEFAULT NULL COMMENT '方法执行耗时, 单位:ms',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='操作日志表';

-- ----------------------------
-- Records of operate_log
-- ----------------------------
BEGIN;
INSERT INTO `operate_log` (`id`, `operate_user`, `operate_time`, `class_name`, `method_name`, `method_params`, `return_value`, `cost_time`) VALUES (1, 5, '2024-07-11 23:14:41', 'com.itheima.service.impl.DeptServiceImpl', 'save', '[Dept(id=null, name=屌毛, createTime=null, updateTime=null)]', 'null', 398);
INSERT INTO `operate_log` (`id`, `operate_user`, `operate_time`, `class_name`, `method_name`, `method_params`, `return_value`, `cost_time`) VALUES (2, 5, '2024-07-11 23:16:55', 'com.itheima.service.impl.DeptServiceImpl', 'save', '[Dept(id=null, name=屌毛3, createTime=null, updateTime=null)]', 'null', 1333);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
